

INSERT INTO HSTB_INVENTORY_PERIOD_BALANCE(ID  , PERIOD_ID  , WAREHOUSE_CODE  , LOCATION_NUMBER  , BATCH_NUMBER  , STOCK_ITEM_NUMBER  , ON_HAND_BALANCE  , TRANSFER_STATUS  , CREATED_TIMESTAMP  , MODIFIED_TIMESTAMP) select MSSQ_INVENTORY_BALANCE_ID.nextval as ID, 201106              as  PERIOD_ID  , 'UTC1'              as  WAREHOUSE_CODE  , NULL                as  LOCATION_NUMBER     , NULL                as  BATCH_NUMBER  , 12345               as  STOCK_ITEM_NUMBER  , 95                 as  ON_HAND_BALANCE  , 0                   as  TRANSFER_STATUS  , current_timestamp   as  CREATED_TIMESTAMP  , current_timestamp   as  MODIFIED_TIMESTAMP from dual;
INSERT INTO HSTB_INVENTORY_PERIOD_BALANCE(ID  , PERIOD_ID  , WAREHOUSE_CODE  , LOCATION_NUMBER  , BATCH_NUMBER  , STOCK_ITEM_NUMBER  , ON_HAND_BALANCE  , TRANSFER_STATUS  , CREATED_TIMESTAMP  , MODIFIED_TIMESTAMP) select MSSQ_INVENTORY_BALANCE_ID.nextval as ID, 201106              as  PERIOD_ID  , 'UTC2'              as  WAREHOUSE_CODE  , NULL                as  LOCATION_NUMBER     , NULL                as  BATCH_NUMBER  , 12345               as  STOCK_ITEM_NUMBER  , 88                 as  ON_HAND_BALANCE  , 0                   as  TRANSFER_STATUS  , current_timestamp   as  CREATED_TIMESTAMP  , current_timestamp   as  MODIFIED_TIMESTAMP from dual;
INSERT INTO HSTB_INVENTORY_PERIOD_BALANCE(ID  , PERIOD_ID  , WAREHOUSE_CODE  , LOCATION_NUMBER  , BATCH_NUMBER  , STOCK_ITEM_NUMBER  , ON_HAND_BALANCE  , TRANSFER_STATUS  , CREATED_TIMESTAMP  , MODIFIED_TIMESTAMP) select MSSQ_INVENTORY_BALANCE_ID.nextval as ID, 201107              as  PERIOD_ID  , 'UTC1'              as  WAREHOUSE_CODE  , NULL                as  LOCATION_NUMBER     , NULL                as  BATCH_NUMBER  , 12345               as  STOCK_ITEM_NUMBER  , 93                 as  ON_HAND_BALANCE  , 0                   as  TRANSFER_STATUS  , current_timestamp   as  CREATED_TIMESTAMP  , current_timestamp   as  MODIFIED_TIMESTAMP from dual;
INSERT INTO HSTB_INVENTORY_PERIOD_BALANCE(ID  , PERIOD_ID  , WAREHOUSE_CODE  , LOCATION_NUMBER  , BATCH_NUMBER  , STOCK_ITEM_NUMBER  , ON_HAND_BALANCE  , TRANSFER_STATUS  , CREATED_TIMESTAMP  , MODIFIED_TIMESTAMP) select MSSQ_INVENTORY_BALANCE_ID.nextval as ID, 201107              as  PERIOD_ID  , 'UTC2'              as  WAREHOUSE_CODE  , NULL                as  LOCATION_NUMBER     , NULL                as  BATCH_NUMBER  , 12345               as  STOCK_ITEM_NUMBER  , 67                 as  ON_HAND_BALANCE  , 0                   as  TRANSFER_STATUS  , current_timestamp   as  CREATED_TIMESTAMP  , current_timestamp   as  MODIFIED_TIMESTAMP from dual;
INSERT INTO HSTB_INVENTORY_PERIOD_BALANCE(ID  , PERIOD_ID  , WAREHOUSE_CODE  , LOCATION_NUMBER  , BATCH_NUMBER  , STOCK_ITEM_NUMBER  , ON_HAND_BALANCE  , TRANSFER_STATUS  , CREATED_TIMESTAMP  , MODIFIED_TIMESTAMP) select MSSQ_INVENTORY_BALANCE_ID.nextval as ID, 201108              as  PERIOD_ID  , 'UTC1'              as  WAREHOUSE_CODE  , NULL                as  LOCATION_NUMBER     , NULL                as  BATCH_NUMBER  , 12345               as  STOCK_ITEM_NUMBER  , 85                 as  ON_HAND_BALANCE  , 0                   as  TRANSFER_STATUS  , current_timestamp   as  CREATED_TIMESTAMP  , current_timestamp   as  MODIFIED_TIMESTAMP from dual;
INSERT INTO HSTB_INVENTORY_PERIOD_BALANCE(ID  , PERIOD_ID  , WAREHOUSE_CODE  , LOCATION_NUMBER  , BATCH_NUMBER  , STOCK_ITEM_NUMBER  , ON_HAND_BALANCE  , TRANSFER_STATUS  , CREATED_TIMESTAMP  , MODIFIED_TIMESTAMP) select MSSQ_INVENTORY_BALANCE_ID.nextval as ID, 201108              as  PERIOD_ID  , 'UTC1'              as  WAREHOUSE_CODE  , NULL                as  LOCATION_NUMBER     , NULL                as  BATCH_NUMBER  , 23456               as  STOCK_ITEM_NUMBER  , 90                 as  ON_HAND_BALANCE  , 0                   as  TRANSFER_STATUS  , current_timestamp   as  CREATED_TIMESTAMP  , current_timestamp   as  MODIFIED_TIMESTAMP from dual;
INSERT INTO HSTB_INVENTORY_PERIOD_BALANCE(ID  , PERIOD_ID  , WAREHOUSE_CODE  , LOCATION_NUMBER  , BATCH_NUMBER  , STOCK_ITEM_NUMBER  , ON_HAND_BALANCE  , TRANSFER_STATUS  , CREATED_TIMESTAMP  , MODIFIED_TIMESTAMP) select MSSQ_INVENTORY_BALANCE_ID.nextval as ID, 201108              as  PERIOD_ID  , 'UTC2'              as  WAREHOUSE_CODE  , NULL                as  LOCATION_NUMBER     , NULL                as  BATCH_NUMBER  , 12345               as  STOCK_ITEM_NUMBER  , 82                 as  ON_HAND_BALANCE  , 0                   as  TRANSFER_STATUS  , current_timestamp   as  CREATED_TIMESTAMP  , current_timestamp   as  MODIFIED_TIMESTAMP from dual;



INSERT INTO TSTB_INVENTORY_TRANSACTION(    ID,    REFERENCE_ID,    LEVEL1_NUMBER,    LEVEL2_NUMBER,    REFERENCE_SOURCE,    WAREHOUSE_CODE,    LOCATION_NUMBER,    BATCH_NUMBER,    STOCK_ITEM_NUMBER,    TRANSACTION_DATE_TIME,    TRANSACTION_QUANTITY,    TRANSACTION_CODE,    TRANSFER_STATUS,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP)select    TSSQ_INVENTORY_TRANSACTION_ID.nextval,    0 as REFERENCE_ID,    null as LEVEL1_NUMBER,    null as LEVEL2_NUMBER,    null as REFERENCE_SOURCE,    'UTC2' as WAREHOUSE_CODE,    null as LOCATION_NUMBER,    null as BATCH_NUMBER,    23456 as STOCK_ITEM_NUMBER,    to_date('20110722', 'YYYYMMDD')  as TRANSACTION_DATE_TIME,    10 as TRANSACTION_QUANTITY,    'I' as TRANSACTION_CODE,    0 as TRANSFER_STATUS,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;
INSERT INTO TSTB_INVENTORY_TRANSACTION(    ID,    REFERENCE_ID,    LEVEL1_NUMBER,    LEVEL2_NUMBER,    REFERENCE_SOURCE,    WAREHOUSE_CODE,    LOCATION_NUMBER,    BATCH_NUMBER,    STOCK_ITEM_NUMBER,    TRANSACTION_DATE_TIME,    TRANSACTION_QUANTITY,    TRANSACTION_CODE,    TRANSFER_STATUS,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP)select    TSSQ_INVENTORY_TRANSACTION_ID.nextval,    0 as REFERENCE_ID,    null as LEVEL1_NUMBER,    null as LEVEL2_NUMBER,    null as REFERENCE_SOURCE,    'UTC1' as WAREHOUSE_CODE,    null as LOCATION_NUMBER,    null as BATCH_NUMBER,    23456 as STOCK_ITEM_NUMBER,    to_date('20110723', 'YYYYMMDD')  as TRANSACTION_DATE_TIME,    10 as TRANSACTION_QUANTITY,    'I' as TRANSACTION_CODE,    0 as TRANSFER_STATUS,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;
INSERT INTO TSTB_INVENTORY_TRANSACTION(    ID,    REFERENCE_ID,    LEVEL1_NUMBER,    LEVEL2_NUMBER,    REFERENCE_SOURCE,    WAREHOUSE_CODE,    LOCATION_NUMBER,    BATCH_NUMBER,    STOCK_ITEM_NUMBER,    TRANSACTION_DATE_TIME,    TRANSACTION_QUANTITY,    TRANSACTION_CODE,    TRANSFER_STATUS,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP)select    TSSQ_INVENTORY_TRANSACTION_ID.nextval,    0 as REFERENCE_ID,    null as LEVEL1_NUMBER,    null as LEVEL2_NUMBER,    null as REFERENCE_SOURCE,    'UTC2' as WAREHOUSE_CODE,    null as LOCATION_NUMBER,    null as BATCH_NUMBER,    12345 as STOCK_ITEM_NUMBER,    to_date('20110905', 'YYYYMMDD')  as TRANSACTION_DATE_TIME,    -5 as TRANSACTION_QUANTITY,    'M' as TRANSACTION_CODE,    0 as TRANSFER_STATUS,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;
INSERT INTO TSTB_INVENTORY_TRANSACTION(    ID,    REFERENCE_ID,    LEVEL1_NUMBER,    LEVEL2_NUMBER,    REFERENCE_SOURCE,    WAREHOUSE_CODE,    LOCATION_NUMBER,    BATCH_NUMBER,    STOCK_ITEM_NUMBER,    TRANSACTION_DATE_TIME,    TRANSACTION_QUANTITY,    TRANSACTION_CODE,    TRANSFER_STATUS,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP)select    TSSQ_INVENTORY_TRANSACTION_ID.nextval,    0 as REFERENCE_ID,    null as LEVEL1_NUMBER,    null as LEVEL2_NUMBER,    null as REFERENCE_SOURCE,    'UTC1' as WAREHOUSE_CODE,    null as LOCATION_NUMBER,    null as BATCH_NUMBER,    12345 as STOCK_ITEM_NUMBER,    to_date('20110805', 'YYYYMMDD')  as TRANSACTION_DATE_TIME,     8 as TRANSACTION_QUANTITY,    'I' as TRANSACTION_CODE,    0 as TRANSFER_STATUS,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;
INSERT INTO TSTB_INVENTORY_TRANSACTION(    ID,    REFERENCE_ID,    LEVEL1_NUMBER,    LEVEL2_NUMBER,    REFERENCE_SOURCE,    WAREHOUSE_CODE,    LOCATION_NUMBER,    BATCH_NUMBER,    STOCK_ITEM_NUMBER,    TRANSACTION_DATE_TIME,    TRANSACTION_QUANTITY,    TRANSACTION_CODE,    TRANSFER_STATUS,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP)select    TSSQ_INVENTORY_TRANSACTION_ID.nextval,    0 as REFERENCE_ID,    null as LEVEL1_NUMBER,    null as LEVEL2_NUMBER,    null as REFERENCE_SOURCE,    'UTC2' as WAREHOUSE_CODE,    null as LOCATION_NUMBER,    null as BATCH_NUMBER,    12345 as STOCK_ITEM_NUMBER,    to_date('20110802', 'YYYYMMDD')  as TRANSACTION_DATE_TIME,     3 as TRANSACTION_QUANTITY,    'I' as TRANSACTION_CODE,    0 as TRANSFER_STATUS,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;
INSERT INTO TSTB_INVENTORY_TRANSACTION(    ID,    REFERENCE_ID,    LEVEL1_NUMBER,    LEVEL2_NUMBER,    REFERENCE_SOURCE,    WAREHOUSE_CODE,    LOCATION_NUMBER,    BATCH_NUMBER,    STOCK_ITEM_NUMBER,    TRANSACTION_DATE_TIME,    TRANSACTION_QUANTITY,    TRANSACTION_CODE,    TRANSFER_STATUS,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP)select    TSSQ_INVENTORY_TRANSACTION_ID.nextval,    0 as REFERENCE_ID,    null as LEVEL1_NUMBER,    null as LEVEL2_NUMBER,    null as REFERENCE_SOURCE,    'UTC1' as WAREHOUSE_CODE,    null as LOCATION_NUMBER,    null as BATCH_NUMBER,    12345 as STOCK_ITEM_NUMBER,    to_date('20110719', 'YYYYMMDD')  as TRANSACTION_DATE_TIME,     6 as TRANSACTION_QUANTITY,    'I' as TRANSACTION_CODE,    0 as TRANSFER_STATUS,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;